Dataset info
| Number of variables | 17 |
|---|---|
| Number of observations | 395471 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 51.3 MiB |
| Average record size in memory | 136.0 B |
Variables types
| Numeric | 7 |
|---|---|
| Categorical | 10 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
Hour has 19072 (4.8%) zeros | Zeros |
Incident_Number has a high cardinality: 349485 distinct values | Warning |
Location has a high cardinality: 18555 distinct values | Warning |
Occurred_On_Date has a high cardinality: 288928 distinct values | Warning |
Offense_Code_Group has a high cardinality: 63 distinct values | Warning |
Offense_Description has a high cardinality: 236 distinct values | Warning |
Reporting_Area has a high cardinality: 879 distinct values | Warning |
Street has a high cardinality: 3919 distinct values | Warning |
Day_Of_Week
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Friday | |
|---|---|
| Wednesday | |
| Thursday | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| Friday | 60217 | 15.2% | |
| Wednesday | 58146 | 14.7% | |
| Thursday | 57778 | 14.6% | |
| Tuesday | 57174 | 14.5% | |
| Monday | 56582 | 14.3% | |
| Saturday | 55526 | 14.0% | |
| Sunday | 50048 | 12.7% |
| Max length | 9 |
|---|---|
| Mean length | 7.15866903 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
df_index
Numeric
| Distinct count | 395471 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 214159.39 |
|---|---|
| Minimum | 8 |
| Maximum | 427330 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 21450.5 |
| Q1 | 106734.5 |
| Median | 214018 |
| Q3 | 322010.5 |
| 95-th percentile | 406466.5 |
| Maximum | 427330 |
| Range | 427322 |
| Interquartile range | 215276 |
Descriptive statistics
| Standard deviation | 123785.0459 |
|---|---|
| Coef of variation | 0.5780042891 |
| Kurtosis | -1.20747082 |
| Mean | 214159.39 |
| MAD | 107281.5061 |
| Skewness | -0.0004958723975 |
| Sum | 8.469382811e+10 |
| Variance | 1.53227376e+10 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[8.000000e+00 3.637495e+05 4.267835e+05 4.273300e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 348671 | 1 | < 0.1% | |
| 160283 | 1 | < 0.1% | |
| 150044 | 1 | < 0.1% | |
| 147997 | 1 | < 0.1% | |
| 154142 | 1 | < 0.1% | |
| 152095 | 1 | < 0.1% | |
| 240160 | 1 | < 0.1% | |
| 238113 | 1 | < 0.1% | |
| 244258 | 1 | < 0.1% | |
| Other values (395461) | 395461 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 427330 | 1 | < 0.1% | |
| 427329 | 1 | < 0.1% | |
| 427328 | 1 | < 0.1% | |
| 427327 | 1 | < 0.1% | |
| 427326 | 1 | < 0.1% |
District
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B2 | |
|---|---|
| C11 | |
| D4 | |
| Other values (9) |
| Value | Count | Frequency (%) | |
| B2 | 62614 | 15.8% | |
| C11 | 54817 | 13.9% | |
| D4 | 49957 | 12.6% | |
| B3 | 45837 | 11.6% | |
| A1 | 42027 | 10.6% | |
| C6 | 28701 | 7.3% | |
| D14 | 25400 | 6.4% | |
| E18 | 22382 | 5.7% | |
| E13 | 22027 | 5.6% | |
| E5 | 17105 | 4.3% | |
| Other values (2) | 24604 | 6.2% |
| Max length | 3 |
|---|---|
| Mean length | 2.33574649 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Hour
Numeric
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.12407484 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros (%) | 4.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| Median | 14 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range | 9 |
Descriptive statistics
| Standard deviation | 6.281465844 |
|---|---|
| Coef of variation | 0.4786216112 |
| Kurtosis | -0.5892760894 |
| Mean | 13.12407484 |
| MAD | 5.165801739 |
| Skewness | -0.4830191296 |
| Sum | 5190191 |
| Variance | 39.45681315 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=24)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 19.5 20.5 21.5 22.5 23. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 17 | 25462 | 6.4% | |
| 18 | 24815 | 6.3% | |
| 16 | 24657 | 6.2% | |
| 12 | 23348 | 5.9% | |
| 19 | 21721 | 5.5% | |
| 14 | 21410 | 5.4% | |
| 13 | 20984 | 5.3% | |
| 15 | 20615 | 5.2% | |
| 11 | 20501 | 5.2% | |
| 10 | 20484 | 5.2% | |
| Other values (14) | 171474 | 43.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 19072 | 4.8% | |
| 1 | 11031 | 2.8% | |
| 2 | 9174 | 2.3% | |
| 3 | 5586 | 1.4% | |
| 4 | 4185 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23 | 13079 | 3.3% | |
| 22 | 16098 | 4.1% | |
| 21 | 17574 | 4.4% | |
| 20 | 19684 | 5.0% | |
| 19 | 21721 | 5.5% |
Incident_Number
Categorical
| Distinct count | 349485 |
|---|---|
| Unique (%) | 88.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| I162030584 | 12 |
|---|---|
| I192008813 | 12 |
| I152080623 | 11 |
| Other values (349482) |
| Value | Count | Frequency (%) | |
| I162030584 | 12 | < 0.1% | |
| I192008813 | 12 | < 0.1% | |
| I152080623 | 11 | < 0.1% | |
| I192003542 | 10 | < 0.1% | |
| I192062990 | 10 | < 0.1% | |
| I172013170 | 10 | < 0.1% | |
| I182065208 | 10 | < 0.1% | |
| I182093874 | 10 | < 0.1% | |
| I172096394 | 10 | < 0.1% | |
| I192009132 | 9 | < 0.1% | |
| Other values (349475) | 395367 | > 99.9% |
| Max length | 13 |
|---|---|
| Mean length | 10.00238197 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Lat
Numeric
| Distinct count | 18538 |
|---|---|
| Unique (%) | 4.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42.32211542 |
|---|---|
| Minimum | 42.2324133 |
| Maximum | 42.39504158 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 42.2324133 |
|---|---|
| 5-th percentile | 42.26839985 |
| Q1 | 42.29726079 |
| Median | 42.32557398 |
| Q3 | 42.34862382 |
| 95-th percentile | 42.37196094 |
| Maximum | 42.39504158 |
| Range | 0.16262828 |
| Interquartile range | 0.051363025 |
Descriptive statistics
| Standard deviation | 0.03197544952 |
|---|---|
| Coef of variation | 0.0007555257862 |
| Kurtosis | -0.6669719893 |
| Mean | 42.32211542 |
| MAD | 0.02685406684 |
| Skewness | -0.2292036149 |
| Sum | 16737169.31 |
| Variance | 0.001022429372 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[42.2324133 42.23400621 42.2341343 42.23478927 42.23493284 ... 42.39308545 42.39350021 42.39380075 42.39476303 42.39504158], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 42.34862382 | 1670 | 0.4% | |
| 42.36183857 | 1651 | 0.4% | |
| 42.28482577 | 1460 | 0.4% | |
| 42.32866284 | 1336 | 0.3% | |
| 42.25621592 | 1238 | 0.3% | |
| 42.29755533 | 1153 | 0.3% | |
| 42.34128751 | 1011 | 0.3% | |
| 42.33152148 | 995 | 0.3% | |
| 42.33511904 | 900 | 0.2% | |
| 42.32696647 | 888 | 0.2% | |
| Other values (18528) | 383169 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 42.2324133 | 10 | < 0.1% | |
| 42.23265556 | 5 | < 0.1% | |
| 42.23287025 | 5 | < 0.1% | |
| 42.23290729 | 3 | < 0.1% | |
| 42.2330858 | 16 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 42.39504158 | 38 | < 0.1% | |
| 42.39448447 | 1 | < 0.1% | |
| 42.394213 | 10 | < 0.1% | |
| 42.39407288 | 2 | < 0.1% | |
| 42.39352862 | 122 | < 0.1% |
Location
Categorical
| Distinct count | 18555 |
|---|---|
| Unique (%) | 4.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| (42.34862382, -71.08277637) | 1670 |
|---|---|
| (42.36183857, -71.05976489) | 1651 |
| (42.28482577, -71.09137369) | 1460 |
| Other values (18552) |
| Value | Count | Frequency (%) | |
| (42.34862382, -71.08277637) | 1670 | 0.4% | |
| (42.36183857, -71.05976489) | 1651 | 0.4% | |
| (42.28482577, -71.09137369) | 1460 | 0.4% | |
| (42.32866284, -71.08563401) | 1336 | 0.3% | |
| (42.25621592, -71.12401947) | 1238 | 0.3% | |
| (42.29755533, -71.05970910) | 1153 | 0.3% | |
| (42.34128751, -71.05467933) | 1011 | 0.3% | |
| (42.33152148, -71.07085307) | 995 | 0.3% | |
| (42.33511904, -71.07491710) | 900 | 0.2% | |
| (42.32696647, -71.06198607) | 888 | 0.2% | |
| Other values (18545) | 383169 | 96.9% |
| Max length | 27 |
|---|---|
| Mean length | 27 |
| Min length | 27 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Long
Numeric
| Distinct count | 18539 |
|---|---|
| Unique (%) | 4.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -71.08301264 |
|---|---|
| Minimum | -71.17867378 |
| Maximum | -70.96367615 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -71.17867378 |
|---|---|
| 5-th percentile | -71.14449084 |
| Q1 | -71.09743705 |
| Median | -71.07766492 |
| Q3 | -71.06259933 |
| 95-th percentile | -71.04036424 |
| Maximum | -70.96367615 |
| Range | 0.21499763 |
| Interquartile range | 0.03483772 |
Descriptive statistics
| Standard deviation | 0.02977167892 |
|---|---|
| Coef of variation | -0.000418829729 |
| Kurtosis | 0.4371903059 |
| Mean | -71.08301264 |
| MAD | 0.02290991993 |
| Skewness | -0.6980397581 |
| Sum | -28111270.09 |
| Variance | 0.0008863528657 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-71.17867378 -71.17806537 -71.17713106 -71.17658221 -71.17442748 ... -70.99789 -70.99677343 -70.99640418 -70.99570006 -70.96367615], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -71.08277637 | 1670 | 0.4% | |
| -71.05976489 | 1651 | 0.4% | |
| -71.09137369 | 1460 | 0.4% | |
| -71.08563401 | 1336 | 0.3% | |
| -71.12401947 | 1238 | 0.3% | |
| -71.0597091 | 1153 | 0.3% | |
| -71.05467933 | 1011 | 0.3% | |
| -71.07085307 | 995 | 0.3% | |
| -71.0749171 | 900 | 0.2% | |
| -71.06198607 | 888 | 0.2% | |
| Other values (18529) | 383169 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -71.17867378 | 23 | < 0.1% | |
| -71.17745696 | 5 | < 0.1% | |
| -71.17680515 | 37 | < 0.1% | |
| -71.17635926 | 1 | < 0.1% | |
| -71.17563839 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -70.96367615 | 1 | < 0.1% | |
| -70.96436489 | 3 | < 0.1% | |
| -70.99536185 | 2 | < 0.1% | |
| -70.99603826 | 5 | < 0.1% | |
| -70.99603971 | 4 | < 0.1% |
Month
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.645860253 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| Median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 3.285107098 |
|---|---|
| Coef of variation | 0.4943087836 |
| Kurtosis | -1.062630776 |
| Mean | 6.645860253 |
| MAD | 2.798181151 |
| Skewness | -0.09916027705 |
| Sum | 2628245 |
| Variance | 10.79192864 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=12)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 4.5 5.5 ... 8.5 9.5 10.5 11.5 12. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 8 | 41159 | 10.4% | |
| 7 | 40548 | 10.3% | |
| 9 | 39348 | 9.9% | |
| 6 | 36405 | 9.2% | |
| 5 | 32441 | 8.2% | |
| 10 | 31707 | 8.0% | |
| 3 | 29644 | 7.5% | |
| 4 | 29590 | 7.5% | |
| 1 | 29513 | 7.5% | |
| 11 | 29287 | 7.4% | |
| Other values (2) | 55829 | 14.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 29513 | 7.5% | |
| 2 | 26561 | 6.7% | |
| 3 | 29644 | 7.5% | |
| 4 | 29590 | 7.5% | |
| 5 | 32441 | 8.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 29268 | 7.4% | |
| 11 | 29287 | 7.4% | |
| 10 | 31707 | 8.0% | |
| 9 | 39348 | 9.9% | |
| 8 | 41159 | 10.4% |
Occurred_On_Date
Categorical
| Distinct count | 288928 |
|---|---|
| Unique (%) | 73.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 6/1/2017 0:00 | 32 |
|---|---|
| 7/1/2015 0:00 | 26 |
| 8/1/2016 0:00 | 25 |
| Other values (288925) |
| Value | Count | Frequency (%) | |
| 6/1/2017 0:00 | 32 | < 0.1% | |
| 7/1/2015 0:00 | 26 | < 0.1% | |
| 8/1/2016 0:00 | 25 | < 0.1% | |
| 8/1/2017 0:00 | 24 | < 0.1% | |
| 1/1/2017 0:00 | 23 | < 0.1% | |
| 1/1/2018 0:00 | 23 | < 0.1% | |
| 5/1/2018 0:00 | 21 | < 0.1% | |
| 9/1/2016 0:00 | 21 | < 0.1% | |
| 4/1/2017 0:00 | 21 | < 0.1% | |
| 2/1/2018 0:00 | 20 | < 0.1% | |
| Other values (288918) | 395235 | 99.9% |
| Max length | 16 |
|---|---|
| Mean length | 14.66629664 |
| Min length | 13 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Offense_Code
Numeric
| Distinct count | 216 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2304.857398 |
|---|---|
| Minimum | 111 |
| Maximum | 3831 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 522 |
| Q1 | 1001 |
| Median | 2907 |
| Q3 | 3201 |
| 95-th percentile | 3830 |
| Maximum | 3831 |
| Range | 3720 |
| Interquartile range | 2200 |
Descriptive statistics
| Standard deviation | 1178.946928 |
|---|---|
| Coef of variation | 0.5115053666 |
| Kurtosis | -1.427621096 |
| Mean | 2304.857398 |
| MAD | 1082.121483 |
| Skewness | -0.4106303256 |
| Sum | 911504260 |
| Variance | 1389915.859 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 111. 111.5 122. 212. 306. ... 3815.5 3820.5 3825.5 3830.5 3831. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3006 | 24997 | 6.3% | |
| 3115 | 23684 | 6.0% | |
| 3831 | 19057 | 4.8% | |
| 1402 | 18991 | 4.8% | |
| 802 | 18608 | 4.7% | |
| 3301 | 17534 | 4.4% | |
| 3114 | 14377 | 3.6% | |
| 3410 | 14173 | 3.6% | |
| 2647 | 11864 | 3.0% | |
| 617 | 11714 | 3.0% | |
| Other values (206) | 220472 | 55.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 111 | 195 | < 0.1% | |
| 112 | 1 | < 0.1% | |
| 121 | 6 | < 0.1% | |
| 123 | 1 | < 0.1% | |
| 301 | 3389 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3831 | 19057 | 4.8% | |
| 3830 | 1349 | 0.3% | |
| 3821 | 422 | 0.1% | |
| 3820 | 1640 | 0.4% | |
| 3811 | 399 | 0.1% |
Offense_Code_Group
Categorical
| Distinct count | 63 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Motor Vehicle Accident Response | 40462 |
|---|---|
| Larceny | 33546 |
| Medical Assistance | 31084 |
| Other values (60) |
| Value | Count | Frequency (%) | |
| Motor Vehicle Accident Response | 40462 | 10.2% | |
| Larceny | 33546 | 8.5% | |
| Medical Assistance | 31084 | 7.9% | |
| Investigate Person | 23684 | 6.0% | |
| Other | 22553 | 5.7% | |
| Simple Assault | 19977 | 5.1% | |
| Vandalism | 19360 | 4.9% | |
| Drug Violation | 19141 | 4.8% | |
| Verbal Disputes | 17534 | 4.4% | |
| Investigate Property | 14377 | 3.6% | |
| Other values (53) | 153753 | 38.9% |
| Max length | 32 |
|---|---|
| Mean length | 15.83528754 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Offense_Description
Categorical
| Distinct count | 236 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SICK/INJURED/MEDICAL - PERSON | 24997 |
|---|---|
| INVESTIGATE PERSON | 23684 |
| M/V - LEAVING SCENE - PROPERTY DAMAGE | 19057 |
| Other values (233) |
| Value | Count | Frequency (%) | |
| SICK/INJURED/MEDICAL - PERSON | 24997 | 6.3% | |
| INVESTIGATE PERSON | 23684 | 6.0% | |
| M/V - LEAVING SCENE - PROPERTY DAMAGE | 19057 | 4.8% | |
| VANDALISM | 18991 | 4.8% | |
| ASSAULT SIMPLE - BATTERY | 18599 | 4.7% | |
| VERBAL DISPUTE | 17534 | 4.4% | |
| INVESTIGATE PROPERTY | 14377 | 3.6% | |
| TOWED MOTOR VEHICLE | 14173 | 3.6% | |
| THREATS TO DO BODILY HARM | 11864 | 3.0% | |
| LARCENY THEFT FROM BUILDING | 11710 | 3.0% | |
| Other values (226) | 220485 | 55.8% |
| Max length | 58 |
|---|---|
| Mean length | 24.02460863 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Reporting_Area
Categorical
| Distinct count | 879 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 111 | 3191 |
|---|---|
| 329 | 2431 |
| 143 | 2348 |
| Other values (876) |
| Value | Count | Frequency (%) | |
| 111 | 3191 | 0.8% | |
| 329 | 2431 | 0.6% | |
| 143 | 2348 | 0.6% | |
| 26 | 2325 | 0.6% | |
| 465 | 2294 | 0.6% | |
| 624 | 2172 | 0.5% | |
| 117 | 2155 | 0.5% | |
| 428 | 1964 | 0.5% | |
| 427 | 1912 | 0.5% | |
| 186 | 1864 | 0.5% | |
| Other values (869) | 372815 | 94.3% |
| Max length | 3 |
|---|---|
| Mean length | 2.893329726 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Street
Categorical
| Distinct count | 3919 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| WASHINGTON ST | 18725 |
|---|---|
| BLUE HILL AVE | 9393 |
| BOYLSTON ST | 9042 |
| Other values (3916) |
| Value | Count | Frequency (%) | |
| WASHINGTON ST | 18725 | 4.7% | |
| BLUE HILL AVE | 9393 | 2.4% | |
| BOYLSTON ST | 9042 | 2.3% | |
| DORCHESTER AVE | 6491 | 1.6% | |
| TREMONT ST | 6401 | 1.6% | |
| HARRISON AVE | 6070 | 1.5% | |
| MASSACHUSETTS AVE | 5883 | 1.5% | |
| CENTRE ST | 5750 | 1.5% | |
| COMMONWEALTH AVE | 5066 | 1.3% | |
| HYDE PARK AVE | 4634 | 1.2% | |
| Other values (3909) | 318016 | 80.4% |
| Max length | 25 |
|---|---|
| Mean length | 11.14997813 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Ucr_Part
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Part Three | |
|---|---|
| Part Two | |
| Part One |
| Value | Count | Frequency (%) | |
| Part Three | 196778 | 49.8% | |
| Part Two | 120525 | 30.5% | |
| Part One | 76650 | 19.4% | |
| Other | 1518 | 0.4% |
| Max length | 10 |
|---|---|
| Mean length | 8.98364229 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Year
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2017.085114 |
|---|---|
| Minimum | 2015 |
| Maximum | 2019 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2015 |
|---|---|
| 5-th percentile | 2015 |
| Q1 | 2016 |
| Median | 2017 |
| Q3 | 2018 |
| 95-th percentile | 2019 |
| Maximum | 2019 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.289487747 |
|---|---|
| Coef of variation | 0.0006392827643 |
| Kurtosis | -1.101560606 |
| Mean | 2017.085114 |
| MAD | 1.082670037 |
| Skewness | -0.03873501439 |
| Sum | 797698667 |
| Variance | 1.66277865 |
| Memory size | 3.0 MiB |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 2017 | 93212 | 23.6% | |
| 2016 | 91543 | 23.1% | |
| 2018 | 91321 | 23.1% | |
| 2019 | 68168 | 17.2% | |
| 2015 | 51227 | 13.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2015 | 51227 | 13.0% | |
| 2016 | 91543 | 23.1% | |
| 2017 | 93212 | 23.6% | |
| 2018 | 91321 | 23.1% | |
| 2019 | 68168 | 17.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2019 | 68168 | 17.2% | |
| 2018 | 91321 | 23.1% | |
| 2017 | 93212 | 23.6% | |
| 2016 | 91543 | 23.1% | |
| 2015 | 51227 | 13.0% |
First rows
| Day_Of_Week | df_index | District | Hour | Incident_Number | Lat | Location | Long | Month | Occurred_On_Date | Offense_Code | Offense_Code_Group | Offense_Description | Reporting_Area | Street | Ucr_Part | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Sunday | 8 | E18 | 9 | I192082859 | 42.259518 | (42.25951765, -71.12156299) | -71.121563 | 10 | 10/13/2019 9:28 | 724 | Auto Theft | AUTO THEFT | 519 | LINCOLN ST | Part One | 2019 |
| 1 | Saturday | 9 | E18 | 20 | I192082751 | 42.262092 | (42.26209214, -71.11670964) | -71.116710 | 10 | 10/12/2019 20:11 | 724 | Auto Theft | AUTO THEFT | 493 | METROPOLITAN AVE | Part One | 2019 |
| 2 | Saturday | 10 | D14 | 15 | I192082680 | 42.352375 | (42.35237455, -71.13509584) | -71.135096 | 10 | 10/12/2019 15:12 | 727 | Auto Theft | AUTO THEFT - LEASED/RENTED VEHICLE | 794 | ALLSTON ST | Part One | 2019 |
| 3 | Saturday | 11 | D4 | 4 | I192082577 | 42.349476 | (42.34947586, -71.07640150) | -71.076402 | 10 | 10/12/2019 4:41 | 724 | Auto Theft | AUTO THEFT | 130 | SAINT JAMES AVE | Part One | 2019 |
| 4 | Wednesday | 12 | A15 | 8 | I192079582 | 42.381846 | (42.38184582, -71.06655134) | -71.066551 | 10 | 10/2/2019 8:08 | 727 | Auto Theft | AUTO THEFT - LEASED/RENTED VEHICLE | 47 | N MEAD ST | Part One | 2019 |
| 5 | Sunday | 13 | B3 | 6 | I192078648 | 42.277964 | (42.27796370, -71.09246318) | -71.092463 | 9 | 9/29/2019 6:39 | 3114 | Investigate Property | INVESTIGATE PROPERTY | 427 | WILMORE ST | Part Three | 2019 |
| 6 | Sunday | 14 | A1 | 3 | I192078647 | 42.367690 | (42.36769032, -71.06586347) | -71.065863 | 9 | 9/29/2019 3:45 | 3115 | Investigate Person | INVESTIGATE PERSON | NASHUA ST | Part Three | 2019 | |
| 7 | Sunday | 15 | B3 | 6 | I192078645 | 42.291816 | (42.29181580, -71.07244098) | -71.072441 | 9 | 9/29/2019 6:00 | 3301 | Verbal Disputes | VERBAL DISPUTE | 450 | ASPINWALL RD | Part Three | 2019 |
| 8 | Sunday | 16 | B3 | 6 | I192078645 | 42.291816 | (42.29181580, -71.07244098) | -71.072441 | 9 | 9/29/2019 6:00 | 1402 | Vandalism | VANDALISM | 450 | ASPINWALL RD | Part Two | 2019 |
| 9 | Sunday | 17 | D4 | 5 | I192078642 | 42.332419 | (42.33241896, -71.07501315) | -71.075013 | 9 | 9/29/2019 5:50 | 3820 | Motor Vehicle Accident Response | M/V ACCIDENT INVOLVING PEDESTRIAN - INJURY | 269 | ALBANY ST | Part Three | 2019 |
Last rows
| Day_Of_Week | df_index | District | Hour | Incident_Number | Lat | Location | Long | Month | Occurred_On_Date | Offense_Code | Offense_Code_Group | Offense_Description | Reporting_Area | Street | Ucr_Part | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 395461 | Sunday | 427321 | D4 | 17 | I050310906-00 | 42.336951 | (42.33695098, -71.08574813) | -71.085748 | 6 | 6/5/2016 17:25 | 3125 | Warrant Arrests | WARRANT ARREST | 285 | COVENTRY ST | Part Three | 2016 |
| 395462 | Thursday | 427322 | E18 | 13 | I030217815-08 | 42.255926 | (42.25592648, -71.12317207) | -71.123172 | 7 | 7/9/2015 13:38 | 3125 | Warrant Arrests | WARRANT ARREST | 520 | RIVER ST | Part Three | 2015 |
| 395463 | Thursday | 427323 | E18 | 13 | I030217815-08 | 42.255926 | (42.25592648, -71.12317207) | -71.123172 | 7 | 7/9/2015 13:38 | 111 | Homicide | MURDER, NON-NEGLIGIENT MANSLAUGHTER | 520 | RIVER ST | Part One | 2015 |
| 395464 | Thursday | 427324 | A1 | 8 | I020695506-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 8:00 | 1806 | Drug Violation | DRUGS - CLASS B TRAFFICKING OVER 18 GRAMS | 77 | NEW SUDBURY ST | Part Two | 2019 |
| 395465 | Thursday | 427325 | A1 | 9 | I020695210-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 9:00 | 1843 | Drug Violation | DRUGS - POSS CLASS B - INTENT TO MFR DIST DISP | 77 | NEW SUDBURY ST | Part Two | 2019 |
| 395466 | Thursday | 427326 | A1 | 8 | I020691165-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 8:00 | 3125 | Warrant Arrests | WARRANT ARREST | 77 | NEW SUDBURY ST | Part Three | 2019 |
| 395467 | Thursday | 427327 | A1 | 8 | I020674147-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 8:00 | 3125 | Warrant Arrests | WARRANT ARREST | 77 | NEW SUDBURY ST | Part Three | 2019 |
| 395468 | Thursday | 427328 | A1 | 8 | I020669075-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 8:00 | 3125 | Warrant Arrests | WARRANT ARREST | 77 | NEW SUDBURY ST | Part Three | 2019 |
| 395469 | Thursday | 427329 | A1 | 8 | I020662996-00 | 42.361839 | (42.36183857, -71.05976489) | -71.059765 | 5 | 5/23/2019 8:56 | 3125 | Warrant Arrests | WARRANT ARREST | 77 | NEW SUDBURY ST | Part Three | 2019 |
| 395470 | Tuesday | 427330 | E13 | 19 | I010370257-00 | 42.302333 | (42.30233307, -71.11156487) | -71.111565 | 5 | 5/31/2016 19:35 | 3125 | Warrant Arrests | WARRANT ARREST | 569 | NEW WASHINGTON ST | Part Three | 2016 |